Use CollegeWebsite
GO

-- ----------------------------
-- Records of Departments
-- ----------------------------
INSERT INTO [dbo].[Departments] ([DepartmentName], [DepartmentDescription], [Status]) VALUES (N'Architecture and Building', N'Architecture and Building', N'1');
GO
INSERT INTO [dbo].[Departments] ([DepartmentName], [DepartmentDescription], [Status]) VALUES (N'Art and design', N'Art and design', N'1');
GO
INSERT INTO [dbo].[Departments] ([DepartmentName], [DepartmentDescription], [Status]) VALUES (N'Business', N'Business', N'1');
GO
INSERT INTO [dbo].[Departments] ([DepartmentName], [DepartmentDescription], [Status]) VALUES (N'Communication and digital media', N'Communication and digital media', N'1');
GO
INSERT INTO [dbo].[Departments] ([DepartmentName], [DepartmentDescription], [Status]) VALUES (N'Community Services and social sciences', N'Community Services and social sciences', N'1');
GO
INSERT INTO [dbo].[Departments] ([DepartmentName], [DepartmentDescription], [Status]) VALUES ( N'Computing and information technology', N'Computing and information technology', N'1');
GO
INSERT INTO [dbo].[Departments] ([DepartmentName], [DepartmentDescription], [Status]) VALUES ( N'Education and training', N'Education and training', N'1');
GO
INSERT INTO [dbo].[Departments] ([DepartmentName], [DepartmentDescription], [Status]) VALUES ( N'Engineering', N'Engineering', N'1');
GO
INSERT INTO [dbo].[Departments] ([DepartmentName], [DepartmentDescription], [Status]) VALUES ( N'Environment and planning', N'Environment and planning', N'1');
GO
INSERT INTO [dbo].[Departments] ([DepartmentName], [DepartmentDescription], [Status]) VALUES ( N'Health and medical sciences', N'Health and medical sciences', N'1');
GO
INSERT INTO [dbo].[Departments] ([DepartmentName], [DepartmentDescription], [Status]) VALUES ( N'Science', N'Science', N'1');
GO


-- ----------------------------
-- Records of Faculties
-- ----------------------------
INSERT INTO [dbo].[Faculties] ([FacultyName], [FacultyDesciption], [DepartmentID], [Status]) VALUES (N'Building and Construction', N'Building and Construction (Building)', N'1', N'1');
GO
INSERT INTO [dbo].[Faculties] ([FacultyName], [FacultyDesciption], [DepartmentID], [Status]) VALUES (N'Interior Design and Decoration', N'Interior Design and Decoration', N'1', N'1');
GO
INSERT INTO [dbo].[Faculties] ([FacultyName], [FacultyDesciption], [DepartmentID], [Status]) VALUES (N'Decoration', N'Interior Design and Decoration', N'1', N'1');
GO
INSERT INTO [dbo].[Faculties] ([FacultyName], [FacultyDesciption], [DepartmentID], [Status]) VALUES ( N'Design', N'Design', N'3', N'1');
GO
INSERT INTO [dbo].[Faculties] ([FacultyName], [FacultyDesciption], [DepartmentID], [Status]) VALUES ( N'Photo Imaging', N'Photo Imaging', N'3', N'1');
GO
INSERT INTO [dbo].[Faculties] ([FacultyName], [FacultyDesciption], [DepartmentID], [Status]) VALUES ( N'Printting and Grapic Arts', N'Printting and Grapic Arts', N'3', N'1');
GO
INSERT INTO [dbo].[Faculties] ([FacultyName], [FacultyDesciption], [DepartmentID], [Status]) VALUES ( N'Graphic Design', N'Graphic Design', N'3', N'1');
GO
INSERT INTO [dbo].[Faculties] ([FacultyName], [FacultyDesciption], [DepartmentID], [Status]) VALUES ( N'Visual Art', N'Visual Art', N'3', N'1');
GO
INSERT INTO [dbo].[Faculties] ([FacultyName], [FacultyDesciption], [DepartmentID], [Status]) VALUES ( N'Accounting', N'Accounting', N'6', N'1');
GO
INSERT INTO [dbo].[Faculties] ([FacultyName], [FacultyDesciption], [DepartmentID], [Status]) VALUES ( N'International Trade', N'International Trade', N'6', N'1');
GO
INSERT INTO [dbo].[Faculties] ([FacultyName], [FacultyDesciption], [DepartmentID], [Status]) VALUES ( N'Commerce', N'Commerce', N'6', N'1');
GO
INSERT INTO [dbo].[Faculties] ([FacultyName], [FacultyDesciption], [DepartmentID], [Status]) VALUES ( N'Department', N'Enable', N'1', N'1');
GO
-- ----------------------------
-- Records of Courses
-- ----------------------------
INSERT INTO [dbo].[Courses] ([FacultyID], [CourseName], [CourseCapicity], [CourseFee], [Status]) VALUES (N'12', N'Dilopma', N'30', N'100', N'1');
GO
INSERT INTO [dbo].[Courses] ([FacultyID], [CourseName], [CourseCapicity], [CourseFee], [Status]) VALUES (N'1', N'Master', N'21', N'100', N'1');
GO
INSERT INTO [dbo].[Courses] ([FacultyID], [CourseName], [CourseCapicity], [CourseFee], [Status]) VALUES (N'16', N'Certificate', N'12', N'100', N'1');
GO
INSERT INTO [dbo].[Courses] ([FacultyID], [CourseName], [CourseCapicity], [CourseFee], [Status]) VALUES (N'1', N'Online', N'12', N'100', N'1');
GO
INSERT INTO [dbo].[Courses] ([FacultyID], [CourseName], [CourseCapicity], [CourseFee], [Status]) VALUES (N'2', N'Dilopma', N'12', N'100', N'1');
GO
INSERT INTO [dbo].[Courses] ([FacultyID], [CourseName], [CourseCapicity], [CourseFee], [Status]) VALUES (N'13', N'Certificate', N'100', N'100', N'1');
GO
INSERT INTO [dbo].[Courses] ([FacultyID], [CourseName], [CourseCapicity], [CourseFee], [Status]) VALUES (N'18', N'Master', N'100', N'100', N'1');
GO
INSERT INTO [dbo].[Courses] ([FacultyID], [CourseName], [CourseCapicity], [CourseFee], [Status]) VALUES ( N'20', N'Dilopma', N'100', N'100', N'1');
GO
INSERT INTO [dbo].[Courses] ([FacultyID], [CourseName], [CourseCapicity], [CourseFee], [Status]) VALUES ( N'14', N'Master', N'100', N'100', N'1');
GO
INSERT INTO [dbo].[Courses] ([FacultyID], [CourseName], [CourseCapicity], [CourseFee], [Status]) VALUES ( N'16', N'Masteo', N'100', N'100', N'1');
GO



-- ----------------------------
-- Records of Courses
-- ----------------------------

INSERT INTO [dbo].[Students] ([PIN],[StudentName], [FatherName], [MotherName], [DateOfBirth], [Gender], [ResidentialAddress], [PermanentAddress], [AdmissionID], [SupportDetails], [Status]) VALUES (N'VNM-84-04-4', N'Hoang Van Nha', N'Hoang', N'Van', N'2011-11-11 00:00:00.000', N'1', null, null, N'1', N'1', N'1');
GO                                                                                                                                                                                                          
INSERT INTO [dbo].[Students] ([PIN],[StudentName], [FatherName], [MotherName], [DateOfBirth], [Gender], [ResidentialAddress], [PermanentAddress], [AdmissionID], [SupportDetails], [Status]) VALUES (N'VNM-84-04-5', N'qưqweqwe', N'qưeqwewqe', N'qưeqweqwewqe', N'2012-04-04 00:00:00.000', N'1', null, null, N'3', N'qưeqwewqewqe', N'1');
GO                                                                                                                                                                                                  
INSERT INTO [dbo].[Students] ([PIN],[StudentName], [FatherName], [MotherName], [DateOfBirth], [Gender], [ResidentialAddress], [PermanentAddress], [AdmissionID], [SupportDetails], [Status]) VALUES (N'VNM-84-04-6', N'ádasd', N'ádasd', N'ádasdasdasd', N'2012-04-04 00:00:00.000', N'0', null, null, N'3', N'ádasdasdasd', N'1');
GO                                                                                                                                                                                                          
INSERT INTO [dbo].[Students] ([PIN],[StudentName], [FatherName], [MotherName], [DateOfBirth], [Gender], [ResidentialAddress], [PermanentAddress], [AdmissionID], [SupportDetails], [Status]) VALUES (N'VNM-84-04-7', N'ádasd', N'ádasd', N'ádasdasdasd', N'2012-04-04 00:00:00.000', N'0', null, null, N'4', N'ádasdasdasd', N'1');
GO                                                                                                                                                                                                       
INSERT INTO [dbo].[Students] ([PIN],[StudentName], [FatherName], [MotherName], [DateOfBirth], [Gender], [ResidentialAddress], [PermanentAddress], [AdmissionID], [SupportDetails], [Status]) VALUES (N'VNM-84-04-8', N'ádasd', N'ádsadsa', N'ádasdsad', N'2012-03-04 00:00:00.000', N'0', null, null, N'6', N'ádsadsadasd', N'1');
GO                                                                                                                                                                                                          
INSERT INTO [dbo].[Students] ([PIN],[StudentName], [FatherName], [MotherName], [DateOfBirth], [Gender], [ResidentialAddress], [PermanentAddress], [AdmissionID], [SupportDetails], [Status]) VALUES (N'VNM-84-04-9', N'Hoàng Văn Chư?ng', N'Hoàng Văn N?i Công', N'Tr?n Th? Nh?t dương ch?y', N'2010-12-05 00:00:00.000', N'1', null, null, N'7', N'Fucking', N'1');
GO

-- ----------------------------
-- Records of Admissions
-- ----------------------------
INSERT INTO [dbo].[Admissions] ([CourseID],[StudentID], [Status]) VALUES (N'1', N'5', N'1');
GO
INSERT INTO [dbo].[Admissions] ([CourseID],[StudentID], [Status]) VALUES (N'1', N'6', N'0');
GO
INSERT INTO [dbo].[Admissions] ([CourseID],[StudentID], [Status]) VALUES (N'1', N'7', N'0');
GO
INSERT INTO [dbo].[Admissions] ([CourseID],[StudentID], [Status]) VALUES (N'1', N'8', N'0');
GO
